Cassandra Chapter Three – Data Model
Updated: 2012-12-31 05:23:00
An Associative Array is one of the most basic and useful data structures where each value is identified by a key, usually a string.- An Associative Array is one of the most basic and useful data structures where each value is identified by a key, usually a string.
SQLAuthority News – Last Post of Year 2012
Updated: 2012-12-31 01:30:03.jpg)
The year 2012 was the most interesting year. If I start listing what was special about this year – I think it will take me 2-3 days to just write a blog post about this subject. Let me pick few things which I would like to specifically call out. SQL in Sixty Seconds Series We [...]The Myth Around 32-bit SQL Server Instances on 64-bit Operating Systems, and AWE
Updated: 2012-12-30 23:36:00
, THE SQL Server Blog Spot on the Web Welcome to SQLblog.com The SQL Server blog spot on the web Sign in in Argenis Fernandez Entire Site Search Home Blogs Downloads Opml Argenis Fernandez The Myth Around 32-bit SQL Server Instances on 64-bit Operating Systems , and AWE I’m taking a break from my DBA Best Practices blog series to talk about this today the series continues after the Holidays I love to be proved wrong . Really , I . do Recently we had a discussion in an distribution list where somebody asked whether a SQL Server 32-bit instance could address more than 4Gb of RAM when running on top of a 64-bit OS . One of the really smart guys in Microsoft SQL Server Support replied sure , just add more RAM and enable AWE SQL will use that memory” . I was much convinced that this wasThe SQL Query Optimizer – when Logical Order can get it wrong
Updated: 2012-12-30 05:32:25
THE SQL Server Blog Spot on the Web Welcome to SQLblog.com The SQL Server blog spot on the web Sign in in Rob Farley Entire Site Search Home Blogs Downloads Opml Rob Farley Rob Farley Owner Principal with LobsterPot Solutions a MS Gold Partner consulting firm Microsoft MVP SQL Server and leader of the SQL User Group in Adelaide , Australia . Rob is also a Director of PASS , and runs training courses around the world in SQL Server and BI . topics The SQL Query Optimizer when Logical Order can get it wrong It’s very easy to get in the habit of imagining the way that a query should work based on the Logical Order of query processing the idea that the FROM clause gets evaluated first , followed by the WHERE clause , GROUP BY , and so on finally ending with whatever is in the SELECT clause . WeSQL SERVER – Fix: Error: The conversion returned status value 2 and status text “The value could not be converted because of a potential loss of data.”. (SQL Server Import and Export Wizard)
Updated: 2012-12-30 01:30:49
Here is the question received from user – the email was long and had multiple request from reader to resolve this error. Scenario: The user was trying to import data from Excel to tables in SQL Server Database. Every time he attempted to import the data he faced following error. He tried using SSIS package [...]SQL SERVER – Weekly Series – Memory Lane – #009
Updated: 2012-12-29 01:30:13
Here is the list of selected articles of SQLAuthority.com across all these years. Instead of just listing all the articles I have selected a few of my most favorite articles and have listed them here with additional notes below it. Let me know which one of the following is your favorite article from memory lane. [...]SQLAuthority News – NuoDB RC2 Available to Download – General Availability in Near Future
Updated: 2012-12-28 01:30:55
Regular readers who are familiar with my blog will be also familiar with my interest in NuoDB. It is a very innovative new age database which follows 100% SQL, ACID and Elastically Scalability. Here is an earlier article on this subject where we explain why sharing will no more required due to the implementation of [...]End of 2012 and news in 2013 for #PowerPivot, #ssas #tabular and BI
Updated: 2012-12-27 18:26:38, THE SQL Server Blog Spot on the Web Welcome to SQLblog.com The SQL Server blog spot on the web Sign in in SQLBI Marco Russo Entire Site Search Home Blogs Downloads Opml SQLBI Marco Russo SQLBI is a blog dedicated to building Business Intelligence solutions with SQL Server End of 2012 and news in 2013 for PowerPivot , ssas tabular and BI This year is going to end , Maya failed their predictions and while this is bad for predictive industry , it’s also good for all of us We’ve seen many news in Microsoft BI : stack Excel 2013 has been RTM’d its General Availability is expected in early 2013 but many early adopters are already using it daily myself included PowerPivot and Power View are both integrated in Excel 2013 and I think that they are the most compelling reason to upgrade your Excel
Nice set of updates to Azure over the last few days - Data Sync now in the HTML Portal - Updates to the CLI
Updated: 2012-12-27 07:56:00SQL SERVER – Creating Database with Different Collation on Server
Updated: 2012-12-27 01:30:24
I recently came across an organization who had very interesting infrastructure setup. Their business domains is analytics. They process millions of the records and how many clients who have case sensitive tags on their server which they want to measure. However, there are many places they do not want to care about case sensitivity. They [...]Love your enemies.. it pisses them off.
Updated: 2012-12-26 19:27:00SQL Replication demystified
Updated: 2012-12-26 01:34:13
THE SQL Server Blog Spot on the Web Welcome to SQLblog.com The SQL Server blog spot on the web Sign in in Rob Farley Entire Site Search Home Blogs Downloads Opml Rob Farley Rob Farley Owner Principal with LobsterPot Solutions a MS Gold Partner consulting firm Microsoft MVP SQL Server and leader of the SQL User Group in Adelaide , Australia . Rob is also a Director of PASS , and runs training courses around the world in SQL Server and BI . topics SQL Replication demystified I spent some time explaining SQL Server Replication to someone recently . They said they hadn’t ever really understood the concepts , and that I’d managed to help . It’s inspired me to write a post that I wouldn’t normally do a 101” post . I’m not trying to do a fully comprehensive piece on replication , just enough toSQL SERVER – Take Database Backup using SSMS – SQL in Sixty Seconds #037 – Video
Updated: 2012-12-26 01:30:52
Whenever I am suggesting something which changes how database works or the existing status of the database, my suggestion along with it is to take the database backup before making such changes. If the changes are in configurations, that can be easily revert but if the changes are such that it will impact the data, [...]BI Beginner: Creating formulas in Excel
Updated: 2012-12-25 03:30:23
Most people haven’t created a formula in Excel using the Equation Editor. If you are writing specifications for what statistical analyses must be performed on a project, it is appropriate to begin with a professional looking formula. Excel’s Equation Editor isn’t difficult to use and you shouldn’t be afraid of it. It is just a collection of templates or frameworks that you nest one inside another. Once you have practiced a few times with the Equation Editor, you should be able to create a formula...(read more)SQL SERVER – Restoring 2012 Database to 2008 or 2005 Version and 2 other Most Asked Questions
Updated: 2012-12-25 01:30:40
Some questions never get old. Let me list a few of them. As the year 2012 is about to end, today I will talk about three of the most asked questions to me in an email. Q 1: What is AdventureWorks and where can I get it? A 1: AdventureWorks is sample database build by [...]SQL SERVER – Fix – Error: 4214: BACKUP LOG cannot be performed because there is no current database backup.
Updated: 2012-12-24 01:30:30
Here is the interesting conversation I recently heard between two teammates in one of the organizations I visited. DBA Jr: I can’t take transactional backup of the database. DBA Sr: What is the recovery model? DBA Jr: How to find the recovery model? DBA Sr: Go to SSMS >> Right Click on Your Database >> [...]SQL SERVER – What is Hekaton? – Simple Words Explanation
Updated: 2012-12-23 01:30:00Readers of this blog will know that I recently attended SQL Server (PASS) Summit 2012. There were, of course, a lot of fascinating subjects and people, but let me talk about one of my favorites right now. Ted Kummert, corporate vice president of the Data Platform group at Microsoft, announced that the new version of [...]SQL SERVER – Weekly Series – Memory Lane – #008
Updated: 2012-12-22 01:30:27.jpg)
Here is the list of selected articles of SQLAuthority.com across all these years. Instead of just listing all the articles I have selected a few of my most favorite articles and have listed them here with additional notes below it. Let me know which one of the following is your favorite article from memory lane. [...]Windows Azure SQL Reporting - Great to see a dramatic price decrease for lower volume users
Updated: 2012-12-21 02:26:00SQLAuthority News – Chrome Browser – Personal Technology
Updated: 2012-12-21 01:30:50
Almost every computer you can buy these days will come with Microsoft Windows installed on it automatically. Also installed automatically – Internet Explorer, Microsoft’s web browser. Many of us use this browser without a second thought, but in this latest Personal Technology Tip and Trick I thought I’d expand your horizons and talk about my [...]SQL SERVER – Difference Between CURRENT_TIMESTAMP and GETDATE() – CURRENT_TIMESTAMP Equivalent in SQL Server
Updated: 2012-12-20 01:30:02A common question – I often get from Oracle/MySQL Professionals: “What is the Equivalent to CURRENT_TIMESTAMP in SQL Server?” Here is a common question I often get from SQL Server Professionals: “What are differences between Difference Between CURRENT_TIMESTAMP and GETDATE ()?” Very simple question but have showed up so frequently that I feel like to write about [...]Scammers on the loose pretending to be Microsoft
Updated: 2012-12-20 00:58:18SQL SERVER – Select and Delete Duplicate Records – SQL in Sixty Seconds #036 – Video
Updated: 2012-12-19 01:30:09Developers often face situations when they find their column have duplicate records and they want to delete it. A good developer will never delete any data without observing it and making sure that what is being deleted is the absolutely fine to delete. Before deleting duplicate data, one should select it and see if the [...]December 2012 Cumulative Updates are available for SQL Server 2008 R2
Updated: 2012-12-18 03:47:00Cumulative Update #5 is available for SQL Server 2012 RTM
Updated: 2012-12-18 03:44:00SQL SERVER – Select the Most Optimal Backup Methods for Server
Updated: 2012-12-18 01:30:13.png)
Backup and Restore are very interesting concepts and one should be very much with the concept if you are dealing with production database. One never knows when a natural disaster or user error will surface and the first thing everybody wants is to get back on point in time when things were all fine. Well, [...]Hypothetical Indexes on SQL Server
Updated: 2012-12-18 00:00:00Sometimes, you have to test out alternative indexing strategies, but the task of creating the candidate indexes would just take too long. Is there another way? Well, yes, why not use the same method the DTA (Database Tuning Advisor) uses, and take the tedium out of the job.SQL SERVER – Auto Complete and Format T-SQL Code – Devart SQL Complete
Updated: 2012-12-17 01:30:52
Some people call it laziness, some will call it efficiency, some think it is the right thing to do. At any rate, tools are meant to make a job easier, and I like to use various tools. If we consider the history of the world, if we all wanted to keep traditional practices, we would [...]Placeholder images for testing reports
Updated: 2012-12-17 00:38:00SQLAuthority News – First SQL Bangalore Event Report – Nov 24, 2012 – SQL Server User Group Bangalore
Updated: 2012-12-16 01:30:53.jpg)
A very common question I often receive - Do we have SQL Server User Group in Bangalore? Yes! SQL Bangalore – we had very first meeting on Nov 24, 2012 and very soon we are going to have another User Group meeting. The goal is to keep up a monthly rhythm of User Group meeting. [...]SQL SERVER – Weekly Series – Memory Lane – #007
Updated: 2012-12-15 01:30:58
Here is the list of selected articles of SQLAuthority.com across all these years. Instead of just listing all the articles I have selected a few of my most favorite articles and have listed them here with additional notes below it. Let me know which one of the following is your favorite article from memory lane. [...]Learn More About SQL Server IO and Query Tuning in These Webcasts
Updated: 2012-12-14 18:50:00SQL Contest – Result of Cartoon Contest
Updated: 2012-12-14 01:30:45Earlier we had an excellent contest ran with the help of Embarcadero Technologies. We had two different contests on the same day sponsored by the kind folks at Embarcadero. Here are the details of the winners. 1) Win USD 25 Amazon Gift Cards (10 Units) We had announced that we will award USD 25 Amazon Gift Cards [...]Database unit testing is now available for SSDT
Updated: 2012-12-14 00:47:47
THE SQL Server Blog Spot on the Web Welcome to SQLblog.com The SQL Server blog spot on the web Sign in in SSIS Junkie Entire Site Search Home Blogs Downloads Opml SSIS Junkie This is the blog of Jamie Thomson , a freelance SQL Server developer in London Database unit testing is now available for SSDT Good news was announced yesterday for those that are using SSDT and want to write unit tests , unit testing functionality is now available . The announcement was made on the SSDT team blog in post Available Today : SSDT—December 2012 Here are a few thoughts about this . news Firstly , there seems to be a general impression that database unit testing was not previously available for SSDT that’s not entirely true . Database unit testing was most recently delivered in Visual Studio 2010 and anyLet's Talk Licensing and Virtualization for SQL Server
Updated: 2012-12-13 19:23:00SQLAuthority News – Speaking at Southeast Asia SharePoint Conference 2013 – Singapore
Updated: 2012-12-13 01:30:49
Two years ago I spoke at Southeast Asia SharePoint Conference 2011, Singapore and I had a fantastic time to present to the Singapore audience. The session was very well received and lots of interest was generated. The event is back again this year and with much bigger scale. I will be presenting on SQL Server and [...]Using Enterprise Data Integration Dashboards Recording Available
Updated: 2012-12-13 00:00:00Visual Studio 2012 and Oracle Development Environment
Updated: 2012-12-12 21:29:00
Creating a complete environment for developing .NET applications that target Oracle requires a little planning and understanding of how Oracle connectivity works. You need to be methodical and test along the way so that you aren’t trying to troubleshoot a multitude of interrelated problems at the end. I’ve made several assumptions in writing this post: You are using 64-bit Windows 7 because you are developer with a lot of ram. I think this post will help you even if you are running Windows 8 instead...(read more)How To Return Document Property Values in Full-Text Search
Updated: 2012-12-12 18:30:00Home Syndication Log in How To Return Document Property Values in Full-Text Search About a week ago I got involved with a question via Twitter that was posted originally to Stack Exchange The question was Is it possible to list document properties via FTS The question refers to SQL Server 2012's new support or property-based search with a syntax that looks like this : SELECT name DocumentName , file_stream.GetFileNamespacePath( Path FROM Documents WHERE CONTAINS(PROPERTY(file_stream , Title' data OR SQL' This functionality has nice synergy with another SQL Server 2012 feature , the filetable feature . So you can store documents in a filetable and search with FTS . Including document properties . There's just one thing missing : no way to get the actual property values after you've searchedNew Article: Stairway to SSIS 11!
Updated: 2012-12-12 13:00:00SQL SERVER – Inviting Ideas for SQL in Sixty Seconds – 12/12/12
Updated: 2012-12-12 01:30:36
Today is 12/12/12 – I am not sure when will I write this kind of date again – maybe never. This opportunity comes once in a lifetime when we have the same date, month and year all have same digit. December 12th is one of the most fantastic day in my personal life. Four years [...]Is the SAN dying???
Updated: 2012-12-12 00:55:00I Could Sure Use Some Windows Azure Code Samples…
Updated: 2012-12-11 03:47:55
THE SQL Server Blog Spot on the Web Welcome to SQLblog.com The SQL Server blog spot on the web Sign in in Buck Woody Entire Site Search Home Blogs Downloads Opml Buck Woody Carpe Datum I Could Sure Use Some Windows Azure Code Samples There are multiple ways to learn , and one of the most effective is with examples . You have multiple options with Windows Azure , including the Software Development Kit the Windows Azure Training Kit and now another one the Microsoft All-In-One Code Framework a free , centralized code sample library driven by developers' real-world pains and needs . The goal is to provide customer-driven code samples for all Microsoft development technologies , and Windows Azure is . included Once you hit the site , you download an EXE that will create a web-app basedSQL SERVER – Asynchronous Update and Timestamp – Check if Row Values are Changed Since Last Retrieve
Updated: 2012-12-11 01:30:16
Here is the question received just this morning. “Pinal, Our application is much different than other application you might have come across. In simple words, I would like to call it Asynchronous Updated Application. We need your quick opinion about one of the situation which we are facing. From business side: We have bidding system [...]SQL SERVER – Get 2 of My Books FREE at Koenig Tech Day – Where Technologies Converge!
Updated: 2012-12-10 01:30:20
As a regular reader of my blog – you must be aware of that I love to write books and talk about various subjects of my book. The founders of Koenig Solutions are my very old friends, I know them for many years. They have been my biggest supporter of my books. Coming weekend they [...]SQL Authority News – Download SQL Server Data Type Conversion Chart
Updated: 2012-12-09 01:30:54
Datatypes are very important concepts of SQL Server and there are quite often need to convert them from one datatypes to another datatype. I have seen that deveoper often get confused when they have to convert the datatype. There are two important concept when it is about datatype conversion. Implicit Conversion: Implicit conversions are those [...]SQL SERVER – Weekly Series – Memory Lane – #006
Updated: 2012-12-08 01:30:17
Here is the list of selected articles of SQLAuthority.com across all these years. Instead of just listing all the articles I have selected a few of my most favorite articles and have listed them here with additional notes below it. Let me know which one of the following is your favorite article from memory lane. [...]SQL Server Backup Questions We Were Too Shy to Ask
Updated: 2012-12-07 00:00:00During presentations about doing database backups and restores, there seem to be two types of questions that are commonly asked - those that come from the floor during the presentation, and those that are asked in private afterwards. These are sometimes more interesting, and challenging to answer well.Disaster Recovery Planning for Data: The Cribsheet
Updated: 2012-12-07 00:00:00Planning for disaster recovery and business continuity aren't amongst the most exciting IT activities. They are, however, essential and relevant to any Database Administrator who is responsible for the safety and integrity of the companies' data, since data is a key part of business continuity.Making the Case for a SQL Server Platform Refresh
Updated: 2012-12-04 00:00:00With the release of Windows Server 2012, SQL Server 2012, and the new generation of Sandy Bridge Xeon processors, your organization is likely to get many tangible benefits from upgrading your current database infrastructure with a complete platform refresh.